TG: sql_for_qa/67

SQL для тестировщика

Какой из следующих SQL запросов выведет имена сотрудников, имеющих зарплату выше средней зарплаты всех сотрудников из таблицы "employees"?

Anonymous Quiz

SELECT name FROM employees WHERE salary > AVG(salary);

SELECT name FROM employees WHERE salary > (SELECT AVG(salary) FROM employees);

SELECT name FROM employees GROUP BY salary HAVING salary > AVG(salary);

SELECT name FROM employees HAVING salary > AVG(salary);

638 answered

www.tg-me.com/ua/SQL для тестировщика/com.sql_for_qa/67

2.6K viewsMar 23, 2023 at 08:58

tg-me.com/sql_for_qa/67

Create: 2023-03-23
Last Update: 2025-07-01 21:50:16

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/67

SQL для тестировщика Telegram | DID YOU KNOW?

Traders also expressed uncertainty about the situation with China Evergrande, as the indebted property company has not provided clarification about a key interest payment.In economic news, the Commerce Department reported an unexpected increase in U.S. new home sales in August.Crude oil prices climbed Friday and front-month WTI oil futures contracts saw gains for a fifth straight week amid tighter supplies. West Texas Intermediate Crude oil futures for November rose $0.68 or 0.9 percent at 73.98 a barrel. WTI Crude futures gained 2.8 percent for the week.

The Singapore stock market has alternated between positive and negative finishes through the last five trading days since the end of the two-day winning streak in which it had added more than a dozen points or 0.4 percent. The Straits Times Index now sits just above the 3,060-point plateau and it's likely to see a narrow trading range on Monday.